Material Database Analysis

Introduction

This notebook is designed to perform the following functions:

• Import MaterialTestData_{######}.xlsx
• Analyze the count of tensile specimens for each material.

Tensile Database Overview

Tensile Specimen Overview

Material Pie Chart

Figure 1: Pie Chart of Tensile Specimen Count

Material Bar Chart

Figure 2: Count Plot of tensile specimens, coded by Material

Orientation Bar Chart

Figure 3: Count Plot of tensile specimens, coded by Orientation

Condition Bar Chart

Figure 4: Count Plot of tensile specimens, coded by Condition

Platform Bar Chart

Figure 5: Count Plot of tensile specimens, coded by Platform

Tensile Data

The following tensile specimens are excluded from the “Standard” dataset:

• specimens with Orientations other than XY or Z
• specimens with Test Temperatures above room temperature
• specimens with Failure Codes
• specimens with unknown Material

Figure 6: Standard tensile data

Figure 7: Standard tensile data, with Metric selection dropdown

Figure 8: Standard tensile data, with Material selection dropdown

Figure 9: Standard tensile data, with Material selection dropdown, split by Orientation and Condition

Single-Material Tensile Data

Nickel Alloy 718

Figure 10: NA718 Tensile Data, by Condition

Figure 11: NA718 Tensile Data, by Platform